﻿CREATE TABLE [audit].[UnitMapping] (
    [UnitMappingId]        INT           NOT NULL,
    [UnitId]               SMALLINT      NOT NULL,
    [UnitName]             VARCHAR (100) NOT NULL,
    [ParentUnitId]         SMALLINT      NOT NULL,
    [ParentUnitName]       VARCHAR (100) NOT NULL,
    [UnitHierarchyId]      SMALLINT      NOT NULL,
    [UnitMappingStartDate] DATE          NOT NULL,
    [UnitMappingEndDate]   DATE          NULL,
    [UnitMappingInputDate] DATE          NOT NULL,
    [AuditId]              INT           NOT NULL,
    [AuditType]            CHAR (1)      NOT NULL,
    [IsAuditRowNew]        BIT           NOT NULL,
    [IsMappingChildUpdate] BIT           NOT NULL
);

